SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109708 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109708 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622064,339885,514444,321054,13623,818341,826931,660060,877407,867574,312538,157905,683038,32211,364573,344648,558676,308573,783987,597922,739934,388002,87980,235269,767388,98493,175351,367013,922351,49534,475631,606776,257801,228168,165535,654017,1001569,392995,403772,982675,921896,340019,973882,762426,1035571,493371,938046,530681,277226,842285,903406,569132,458350,506762,187669,806725,756593,851979,227535,667659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]