SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415258 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415258 [ RunTime:0.002975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15950,701313,204924,668180,468995,691419,723266,142605,900299,630391,424374,435312,175902,996677,256708,469912,954157,686976,680146,173058,734434,948445,154050,313615,852057,763966,773546,419074,677830,783997,614589,188278,743700,296519,207780,329986,505456,494141,599499,325871,479267,749685,206924,5971,453273,358857,243969,762952,329875,970099,257597,480193,361981,600353,50553,7490,206399,451470,387415,885838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]