SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428481 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428481 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325381,584541,1002347,543885,48390,255530,58046,1016496,80530,876759,213296,483819,333086,208638,56911,548260,880830,912740,270794,750618,1030612,569157,398775,927557,695795,914662,787470,870736,251183,666950,28759,276552,536527,999460,108809,283145,650475,796028,917318,44737,417267,613933,256022,835555,580541,871635,776296,868183,1000154,399696,71198,442594,184274,451561,944602,43676,93771,93223,42895,1024463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]