SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40778 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40778 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560983,144176,822974,212739,554927,956880,472782,1017342,982674,921727,20781,649469,859653,709097,966278,1039599,92300,372594,561471,675750,700437,228003,708447,238972,316129,849334,881848,776360,766198,97361,828269,58669,804972,85922,477592,132391,423798,538590,154246,678449,561206,375914,243515,265694,188723,232417,532921,998677,979434,972808,476628,576870,196162,826279,133038,829588,206192,257973,459891,252703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]