SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491535 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491535 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242699,63461,852394,353720,1015939,570936,232153,825577,1023566,835218,671461,912910,937026,1034542,439006,989477,317958,136902,461592,918982,728137,971074,35025,564182,410847,260839,70904,775994,217128,698600,103923,496104,959628,721006,289062,845295,424875,374331,941026,1032050,383175,328683,981338,782976,582023,109618,436641,500617,297774,412073,204389,115696,205393,661916,527652,401934,380391,136480,21543,833354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]