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` = 1036541 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036541 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213021,768297,640109,717539,399280,581208,166489,417612,454836,398828,528359,138717,331099,1025988,619426,95404,909403,914288,294428,244019,376937,25037,919185,230637,534361,519690,824370,27683,555274,132596,605751,651139,641777,136246,465403,173731,941254,384156,228786,703997,1032915,640787,949370,642314,695930,441836,672862,54113,803405,790934,909616,607253,764060,473651,831767,799726,309664,667933,268858,392646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]