SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421047 LIMIT 1 [ RunTime:0.001723s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421047 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145981,339740,907724,574369,689546,1042233,1036454,771923,92553,161191,778021,358534,882492,1034079,904079,108819,125026,188748,402124,929662,122243,32496,492652,797219,800571,110978,487104,91576,1042013,946444,2822,954856,178534,996496,225169,605918,17897,783567,629269,418528,631819,344539,774763,316585,1036046,19585,640674,74290,8021,130437,425826,624994,252985,369704,647933,118029,432647,131767,531796,286438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]