SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309758 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309758 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342205,851110,751010,1041779,150866,451180,440095,801940,591557,143110,545525,353664,43428,354959,244073,431821,338195,568740,87129,120714,180398,1014044,556694,417851,40376,598002,301696,85017,638496,510910,179005,340409,930970,886807,511995,481468,748985,874406,78952,509315,393302,6401,762756,1021865,744701,1015383,281248,614282,344705,946782,468824,706813,708573,963380,209173,401297,882767,550410,949440,7335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]