SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478213 LIMIT 1 [ RunTime:0.001004s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478213 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403356,182029,606928,262582,1005046,649784,509729,633978,443834,488767,513440,612825,303431,300568,462948,805628,838388,282954,47145,74629,122102,170123,187668,151668,587950,794831,422233,459490,385316,704461,406563,794630,775951,180288,501095,918911,219070,671727,90930,73011,648773,271281,43096,88390,1004653,761746,305576,939610,347581,202063,445220,116205,482026,709301,549772,287936,144971,711964,634914,837854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003194s ]