SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047705 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047705 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817209,589420,85623,748501,448835,47025,124073,436952,683983,752405,163410,27788,887455,154420,812352,788025,651308,1003830,562858,1025891,887536,617254,606788,561284,175966,818094,192592,987989,150854,169987,133013,639196,11601,153326,455088,174237,322100,289795,785553,922796,733120,501531,550627,405214,297020,101852,82595,436871,480427,663466,755084,107624,647685,1021250,852522,237911,228561,406903,584075,888869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001287s ]