SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565822 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565822 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448510,145564,46549,735316,590722,922073,924365,271342,532080,923989,662779,409646,688525,266450,45154,477872,548518,539527,1040096,344859,317866,371293,507999,678993,147891,237745,217168,1026389,776297,825593,13122,702000,139955,189125,254087,777214,8169,990922,845126,520157,29582,68792,543579,451615,585248,278347,270624,468044,519318,155391,564909,105915,351227,394039,104500,555643,199853,907202,477424,531242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]