SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414444 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414444 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649174,804812,623821,206392,64779,332044,517103,74889,963251,276563,381810,140531,20515,341709,220556,305865,300680,868329,384125,243995,902292,58619,195715,745981,127878,748431,32666,382114,641261,239056,565572,701904,63169,246255,932815,235320,998673,256720,218512,273018,520780,775778,985554,611691,283840,438531,648224,639120,815848,887889,494239,353710,19017,748753,524515,403518,963093,206718,37686,153456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414444 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414444 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]