SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100615 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100615 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028515,137497,871865,274131,1025389,529217,100424,405497,370654,663433,555825,443904,250106,910711,376539,927073,400162,697545,174620,406670,1006502,32722,212710,224099,37503,866383,101932,767907,20759,351019,1002322,275223,264907,600986,722314,748684,373329,232381,69771,118243,309768,810889,731036,442972,865735,768650,730603,807372,248468,124834,39518,758738,853134,252074,763593,225104,746528,76451,363751,397982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]