SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501972 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501972 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493034,1033787,261482,952405,775734,802545,487565,1048735,666676,166323,480766,304857,492086,68007,162486,243108,304163,4780,1011249,17682,653018,6802,9354,605436,561973,943344,917016,648160,287300,55753,197440,158127,256876,775441,616135,819691,90312,376241,230229,278088,480483,1014040,452363,883951,490632,971194,819472,2586,837240,945493,350642,902937,882191,729742,1015297,710332,164283,851381,917571,172410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]