SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410982 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410982 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728549,579553,217530,206368,987664,921632,38795,932843,963935,976456,624814,438010,877193,792547,746147,256230,934679,944384,293430,699889,335116,864077,948934,313395,52511,858821,115499,1008379,89238,12841,662591,769636,603111,400334,8317,134392,824577,190931,1033832,941651,821852,797705,965032,625774,353756,822115,787908,19699,259174,863423,278570,539495,914442,315361,496200,566407,545123,854453,60526,40992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]