SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452726 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452726 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393139,251405,873962,676337,80662,520454,471145,884403,517220,739750,976273,937924,266310,784342,160925,949002,757330,148449,827363,979067,601704,204528,1013213,616050,246791,868801,953622,579631,987026,172506,247153,93735,429455,846312,601143,323677,78969,780724,375080,678194,621313,101000,718818,236344,723865,363997,638149,506075,649243,153838,471253,853492,1010309,358030,702055,961569,490341,747734,144989,248343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002665s ]