SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016662 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016662 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693916,482345,194815,652738,272810,997035,796615,979653,140966,1021842,991902,396069,841952,127472,671910,423681,61290,193918,219606,283828,817405,314028,307819,368201,840061,564674,839621,920092,380259,379849,348304,1029874,90703,359820,128692,370557,183866,1043645,612718,972458,110227,127263,349939,1022274,559156,47251,936900,1029035,242795,868657,280002,772456,434020,1041736,853257,171225,706237,603606,229429,936905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]