SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105080 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105080 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042079,672631,280125,638702,678410,134899,464794,23527,970910,149215,319292,978182,427879,681141,104899,942040,269464,3795,532535,127961,534926,36653,3901,82277,264549,805753,1035726,445591,485694,467735,278378,552495,589457,602800,861396,624393,136439,989861,1020820,126936,370379,378084,519307,97017,574987,699341,260801,285566,29662,742635,352845,58087,463850,85862,950575,429638,172029,159611,463912,498269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]