SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463499 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463499 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914021,505135,304940,695731,81400,46665,676879,157017,467011,729116,619776,610051,683275,439963,550619,72282,41430,824201,189971,762836,696547,805907,500567,805285,70006,312014,29742,57654,216821,130320,167209,608614,167854,821649,35519,96274,851645,659137,478319,703788,614847,1048241,195506,99599,393971,676253,951386,791383,998341,366637,502344,16129,341048,498758,638411,140717,75141,511768,616585,45278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]