SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803741 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803741 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681451,581174,492533,514643,878807,288314,108678,897467,135866,605645,128797,425101,49516,964403,1024347,668591,244747,826866,575723,231174,423198,235874,206460,522377,476380,566679,706931,874363,199873,786152,602918,918328,239087,413221,789087,370988,824172,363595,912578,628983,1048240,136632,9803,202553,240211,487484,846273,704733,818652,578412,460170,184861,416795,522151,274876,169377,815063,257989,882844,1033656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]