SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349673 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349673 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328045,387525,370460,407697,889428,1024848,151536,363019,61098,635881,925105,121037,568907,896533,971039,271023,467288,490421,384074,492003,233420,882714,385217,667633,804599,160762,902575,104989,549939,43669,446349,371659,572339,730655,986859,201486,434989,690217,69640,303227,388769,610852,768340,531682,215872,706955,776336,974897,680240,482970,99318,278901,660793,736734,923619,457709,735920,473704,282147,969752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]