SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048517 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048517 [ RunTime:0.005337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848025,673006,640254,30576,579446,719698,553283,166122,895320,228719,291486,566365,341957,968090,232351,866923,448115,522594,849532,821643,469912,796740,2520,222740,705587,111396,99937,732402,838540,299246,1019037,869478,454119,160559,737229,74017,902866,683011,506203,661089,514520,721278,616318,918290,107595,246502,422714,339083,463422,1011537,952320,678577,535161,110515,371271,335826,181698,692316,129119,916403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]