SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405701 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405701 [ RunTime:0.004662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673288,964343,622849,485283,35634,824622,1040072,932327,876871,981025,1011849,861621,157033,203312,7773,357708,44405,94019,590947,794273,837438,401190,6481,138435,680738,112051,225079,727693,1005956,877359,753157,439807,440061,63678,159746,634667,174789,5410,206253,756049,275170,79192,814662,775644,882587,554065,740586,585637,686519,148480,143828,286309,676649,535582,214452,717286,264680,358533,507955,644424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001067s ]