SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334606 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334606 [ RunTime:0.003448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35628,135097,483398,918513,1030305,269787,613619,402838,1017187,775325,608161,744021,616911,94342,1010987,62351,511024,758445,848816,871152,470571,767025,572074,580818,887132,174926,571678,702435,575493,527699,752237,445114,714894,1026663,774239,162037,648990,337273,805727,621794,384428,14441,198102,1014161,760288,518069,868609,347585,207491,107711,962624,470889,452530,937175,694455,81014,86595,649591,1021450,640707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]