SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566545 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566545 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487894,742558,516128,64111,808422,653202,212490,69853,137089,810400,113028,611033,722369,388881,239549,347729,518195,831216,533738,499643,254290,541520,792835,424502,615711,547321,924766,333856,375074,375235,865568,779247,815839,491448,955033,308807,202675,64669,15282,115812,69101,40578,660970,669351,86180,522958,970642,277037,377273,304289,321963,90045,959598,347112,11478,36850,245718,967339,112335,62376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]