SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564451 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564451 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599323,66537,473784,899861,119930,606778,996856,831038,409107,56277,331087,424575,926132,501208,53257,930770,634050,243376,381162,734902,129739,540835,810708,385173,106981,301889,935334,439952,40465,855267,556118,53410,995233,342520,905754,796310,217011,275360,589353,675276,873130,979093,541044,730065,259046,383261,999691,184787,816883,864706,422391,318515,981848,546521,607186,52843,263889,557983,633149,436906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]