SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429441 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429441 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940270,505285,41914,401636,291400,230658,1033360,315920,623873,440585,368195,1036858,481179,651141,960853,103420,703203,768977,558720,459503,976907,619431,259154,1027818,569012,987303,1005148,440133,94569,495094,386434,1021009,10773,298726,387908,182720,66888,600038,631768,467308,128781,626758,381700,920891,233385,526229,814670,970651,846394,207556,459957,827986,411899,899046,460849,964500,365310,822944,486207,408876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]