SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591398 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591398 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482830,1042302,208642,686808,569154,355766,681930,500222,1027299,1002263,1041182,43160,486111,646640,707217,317916,84591,389293,372640,633603,289786,234716,813865,572805,794297,199494,328254,978830,40020,981657,406764,657910,812263,281405,929208,123642,1011082,818746,931288,588244,641842,175419,622646,414036,792673,987794,448336,651795,499171,315560,792485,753904,1031490,728660,814235,742472,151761,288658,928662,746939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]