SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291746 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291746 [ RunTime:0.001388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259625,67693,29881,45252,926588,54066,719160,905246,339167,1048071,491624,1042621,49835,683818,772998,121667,70634,479578,808327,700070,500908,1005671,597555,264072,180977,193502,154249,526879,262831,472535,548361,553205,828900,91244,544924,497320,92986,277256,110161,916194,603430,375282,171278,639929,831559,260585,682926,472139,731653,296133,990382,807839,689420,603493,817134,252532,1017895,898987,666899,410290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]