SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529102 LIMIT 1 [ RunTime:0.001245s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529102 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795692,176816,455391,685108,345479,895901,464330,866515,285425,746944,1022428,528275,886317,1024542,168878,912664,32545,751483,110207,851676,677677,1006304,1009680,121351,444391,49030,164731,389130,865967,83908,931317,435918,159341,158278,669172,163394,748954,818029,773191,770490,111116,795884,40443,666334,601190,406890,339569,861239,75171,816677,222902,978630,196089,585016,658360,861297,257636,46630,42599,605322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]