SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429011 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429011 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987916,765270,955733,187211,270787,63107,1042545,728142,771161,722468,180019,601568,864566,965641,569640,216240,725343,340787,839424,953808,918599,675698,131623,183671,153749,604794,980266,331898,23942,369582,696025,292383,453807,514792,824778,153893,636240,821162,176455,888914,791583,722002,106230,723,368103,742257,730891,556155,1045673,92450,263927,229566,689338,203452,102869,375846,800687,470212,11532,497190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]