SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431041 LIMIT 1 [ RunTime:0.002088s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431041 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215861,424538,685644,666182,999029,109104,507010,477030,104294,329030,545686,1046282,173342,832008,948715,482376,413845,954116,428103,762200,271570,882003,963288,352132,675591,266312,262864,918553,525507,129888,870331,740548,324813,150489,510524,94312,1034756,948071,909975,700384,569523,669079,842752,971331,461256,270030,563333,1048370,453737,866953,363832,717567,171171,280454,771858,435708,465062,780928,511449,831266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]