SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438953 LIMIT 1 [ RunTime:0.001733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438953 [ RunTime:0.004389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785389,893495,505929,45663,614396,855917,987395,355930,380947,619564,517141,719167,840702,398469,507119,846710,966246,509006,31502,613032,249108,405708,907450,914810,230615,1020309,295652,50454,527261,410015,897763,813104,282048,134848,820530,999442,556008,1017608,647228,275097,141874,514402,1002269,856223,489476,144177,988093,597624,829959,59618,509312,780041,697422,163911,320434,1032546,952616,540377,621205,77115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000869s ]