SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416449 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416449 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412355,410560,135336,504902,565768,1017957,475988,1025255,794943,879401,376677,273353,1009105,853359,165024,844578,151731,39394,784899,853165,956360,985948,425242,1039041,596196,273766,509740,603902,478629,548367,134719,655722,737539,266966,599531,43399,810534,493543,877429,59373,964232,224469,223059,268163,77524,371216,559758,42886,40347,655937,570139,594385,1029029,539812,273921,544782,735822,319969,513998,195353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]