SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284821 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284821 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181459,336548,690723,348780,229474,105052,1002521,175677,983754,774155,400899,994837,164188,642067,862830,98822,197410,1002875,201463,600647,715311,994779,377759,1043592,47994,38570,920776,896146,294022,701971,172734,854230,760868,401294,1013225,1012284,653243,278277,663454,125991,741191,399778,934634,827864,37674,23418,154190,139375,940402,440013,480748,111018,1015354,958107,595146,327990,345372,184859,287231,808602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]