SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580833 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580833 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791281,972216,507657,628873,288649,614053,973196,779213,37154,828260,936657,180821,814295,327506,537187,625456,157409,122592,663883,601785,111193,245022,979399,416085,965451,149523,881103,884880,711688,744296,52188,477926,318313,856506,553495,522056,81564,199711,798688,596014,216327,97015,110642,675665,951050,65813,712378,288878,679012,960612,894431,398150,557860,608714,385371,545414,917881,623847,131830,943534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]