SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35409 LIMIT 1 [ RunTime:0.000605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35409 [ RunTime:0.002707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94874,320920,807255,154072,154672,840824,219440,119891,144230,791222,931413,243230,339202,981279,485755,764578,586400,743355,988093,481876,606491,77119,400036,686340,848780,282114,118314,664457,807171,871119,385910,392162,863757,386702,13647,715914,554885,695154,102509,135046,931793,1031080,5168,996372,314281,528887,180237,895189,770460,525954,36894,393740,825487,551443,355889,608822,769688,418183,1040479,430117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]