SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034044 LIMIT 1 [ RunTime:0.002395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034044 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017334,74045,67160,112924,337341,553191,676164,100760,696026,829195,685644,787745,606947,409413,910402,761219,500319,113516,360171,980445,197995,629756,1048568,239353,421568,88632,907619,631060,381518,666533,266111,946007,19556,734302,351543,414598,464606,464192,818313,556309,950218,690470,774424,304439,135572,322121,33995,539091,993460,825819,980025,463801,757149,1013578,9633,100898,336734,437349,1037782,232568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]