SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029055 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029055 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372973,829575,409011,405129,802866,565473,871588,994441,599756,408687,44707,98230,161200,884102,33982,534478,931439,1004371,883992,68083,256253,733203,255551,258850,355355,827642,689477,87345,696273,780074,289653,625594,990568,253800,355750,314144,806765,678877,407902,453630,400899,281318,209718,8719,819141,605754,253890,973091,148611,314499,365492,204290,464975,37297,582038,294223,456093,136060,963737,401020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002883s ]