SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014360 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014360 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853457,850121,919347,679378,81001,136299,210406,801861,369945,740663,714871,382010,4087,522653,236352,679056,529965,469160,7037,359790,1030719,272694,794199,221000,11548,518884,419920,204081,170750,229814,868904,383999,927881,598378,461918,336253,81127,596765,769259,631955,985263,526020,629536,528766,565852,51787,49559,364465,505945,700171,837755,619232,65301,20587,682903,705358,871920,891943,213933,672861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]