SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146812 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146812 [ RunTime:0.003589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409420,548741,559533,829291,831422,1045081,829949,164168,213463,488038,696688,819673,398463,13304,558277,485160,745135,675769,500205,6261,233256,777612,205765,178167,419957,707274,789070,656543,772921,640847,791814,611570,928763,215534,1015556,849304,653374,702714,958847,304812,808249,121629,108730,858450,806818,570472,642239,478239,131984,999249,926830,317286,486020,135644,672036,139434,316664,686403,451392,413050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001260s ]