SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442180 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442180 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694805,74446,1012351,339617,607036,910368,892113,691600,729753,986184,740874,289941,211233,305044,894500,412491,460117,124973,812322,363787,191519,618297,55323,839966,840226,158172,457562,969291,896786,184513,913749,239399,712843,508576,551763,753944,282682,734477,613195,875632,758246,754726,324966,999183,684031,65786,1006504,982013,492232,648541,458586,25428,546349,82639,478439,33602,113807,947194,320289,458657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]