SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442383 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442383 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031132,739221,34056,516866,701967,604828,173744,232790,231172,112588,960670,46139,25392,958869,182575,385613,467716,822152,326451,328468,151842,925002,457191,608431,450557,1012099,780291,769867,87248,498275,697545,496092,189013,678201,676541,303701,600291,304787,260213,707934,194245,349247,174243,165832,987057,616958,993161,526346,677538,643816,497921,205376,743053,906666,361167,945659,989504,539993,486609,98805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]