SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367806 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367806 [ RunTime:0.004631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363571,188682,310179,705600,323631,893390,232691,316243,836489,113754,166473,782173,786475,841972,928226,378689,837241,542018,522543,261485,871033,436748,558383,829068,94404,849104,557090,229444,104516,700769,638408,104584,145608,588933,967599,693202,636396,684396,662941,75890,953015,280962,758243,498942,1039032,117010,590810,597802,259995,869938,897443,220692,557069,363835,143749,245019,880795,16752,170971,401350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]