SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 740341 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 740341 [ RunTime:0.003349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877216,658055,200860,1016929,142489,544130,389360,948744,1035242,739017,8622,671154,345352,265557,242375,564303,362192,667850,144223,279216,1048218,700752,578834,921207,786047,131464,383647,537046,201237,887673,992480,249886,293066,268252,292809,658038,223822,402744,657565,941010,560321,300409,794005,301841,844063,507276,744723,794696,503994,526770,664082,486413,629736,210402,657461,256739,430013,1013500,406290,495564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 740341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 740341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001056s ]