SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39452 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39452 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489426,508201,426186,99492,946288,588508,415228,98714,118829,157680,373009,289040,838132,267302,799038,331673,222680,694782,953581,78020,712599,788741,58190,971382,565520,883974,554698,486226,524568,845326,219412,271755,923930,788752,1027331,971387,526007,628736,645235,720264,822094,288840,1041707,332647,39209,909817,240807,499588,679113,1545,764486,404662,672786,603584,181959,674568,471825,868976,943985,402438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]