SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 126203 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 126203 [ RunTime:0.003849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78628,348391,691354,374116,950590,993786,1029707,392076,638847,930412,1004477,412540,295317,1022884,257054,72010,642324,479834,108399,438591,526628,610232,868262,844606,680340,406374,500478,588149,540349,55415,69777,469622,50732,215871,695528,429813,188100,1032911,570179,319680,768514,948284,101917,266627,160008,69207,389533,244349,678100,1005507,113247,265645,775488,847259,992890,988628,947858,169181,876529,754596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 126203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 126203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]