SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499669 LIMIT 1 [ RunTime:0.001658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499669 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845016,219952,552448,834863,885676,276418,565858,310860,479450,790355,1018062,575266,553525,198447,446228,345727,937889,1020753,798773,562793,105924,540136,560626,709506,782592,238213,94768,304698,997438,471248,909251,992403,779997,97488,26061,721355,961381,564415,156004,404637,314121,426091,136321,84118,392813,807044,401983,997927,708807,816259,345591,733301,833846,101030,874883,463592,1004300,609907,943505,51519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499669 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499669 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]