SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460445 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460445 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190883,1019980,388284,897317,255464,419791,879961,279052,408097,378864,70844,998583,484286,161480,649986,191043,916062,2884,307624,443244,586609,829169,1038820,78035,790841,997114,553082,76039,709877,2233,936527,766862,534095,375675,1007612,622249,528769,819957,521255,456339,947926,861316,63519,83444,198990,930768,569549,104155,1037554,115601,908527,660874,54717,420196,449172,901320,42920,552421,114482,557599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]