SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309560 LIMIT 1 [ RunTime:0.002928s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309560 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430297,737255,191723,809345,1030119,494238,107070,662165,621600,935697,558633,924243,225458,163334,421980,1038563,717248,863571,949688,1043414,360257,1014957,273982,1004348,392555,495072,742186,384187,381156,240705,420245,49938,587290,492187,180714,858383,199601,1043525,339470,1001431,297021,752613,363474,626882,1009971,198490,179487,769442,1015492,1014233,192772,313193,861853,194457,770122,207868,124192,814636,207837,974068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]