SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416150 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416150 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336902,225324,183136,722629,1038386,664446,771544,707464,345344,928186,225834,152756,181968,1042627,65600,380585,588265,340823,964298,685145,1021700,655908,1291,406217,432778,128436,650155,416147,895304,685526,8008,41797,607227,993625,305046,22818,930830,930601,984573,312148,648829,690559,124449,576979,277164,1007477,768139,65613,449893,223776,611495,1019961,371936,965273,160753,1011102,614599,672050,485420,868697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]