SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589822 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589822 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157014,604155,836202,919635,992770,890310,401206,700466,978470,644986,14544,354904,347459,170629,652572,2512,591039,728842,573640,325355,534769,534475,174674,552657,247560,805818,669384,136116,1007365,205957,49105,568173,755745,638191,366225,687175,1046455,411215,392485,1018220,197246,884944,52239,866615,482438,771228,198556,687786,851891,262688,393304,143019,1007200,298325,395719,500820,792556,47645,388965,620785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]