SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601057 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601057 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272607,410114,394603,1038727,854321,939919,649131,301686,74138,173557,311906,2010,133768,847217,849460,548774,331974,780506,708200,124769,135490,824966,913518,75958,718010,1046049,784538,872748,914634,336118,702622,152185,701910,789626,1002479,650762,960557,689707,680930,63543,523761,366821,248135,48898,877455,43915,975216,385685,5836,928236,717170,118166,81608,963723,984451,613753,252730,312084,165487,540409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]