SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449396 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449396 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777932,547109,168842,678442,879571,771485,637357,459432,373856,340438,533147,30544,575784,125221,244359,96799,436890,609786,7686,180564,302193,379914,828537,398075,606317,725561,1028791,469629,923616,31739,1004029,231284,73996,516468,788113,8114,326316,12483,759377,845634,19422,580234,325859,535039,966085,372561,92282,433138,920446,282163,401600,444400,950280,393026,96341,855101,724998,397340,875103,694935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]