SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419852 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419852 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866727,153218,602671,1047735,973004,477235,401497,141290,862979,721332,153911,682749,233798,914664,475200,86538,421195,855051,766945,806483,338002,340186,571635,712311,671348,703855,332304,181728,1030533,570507,602399,177999,616625,553384,52983,357762,1037447,14034,665436,613024,885650,471467,524714,201086,29479,579598,487360,787654,415055,686024,380747,144426,98477,1001219,485920,829044,313941,1022232,493033,344445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]