SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803143 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803143 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423603,315663,279203,108121,265429,504559,726923,365856,609255,451207,686446,669843,757271,510885,710345,758673,243751,903431,17267,380492,707585,257702,884387,103776,440588,859147,578440,992888,953244,264227,22227,946133,331242,323525,495914,500301,342969,21655,229593,1008316,338848,925271,846398,838151,661973,993552,871733,159268,283609,608080,367026,455987,878725,919646,592715,412169,235108,511140,599972,36856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]