SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402260 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402260 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502908,524666,1008914,136348,229849,714300,203336,162368,650762,129953,607115,87412,921119,810285,415830,855506,623622,571660,1019770,1013518,976553,545580,893034,873457,347906,1027284,1023846,823409,476447,560098,18739,183096,921093,864002,405020,430264,66359,468934,1022632,712882,717571,555443,805995,829556,353253,874969,959429,620681,367201,501396,555687,458897,637631,640393,113570,867435,545550,516146,599974,780123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001606s ]