SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916643 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916643 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548802,984574,308118,729015,954311,883195,735897,402053,143119,809689,813298,90804,474370,78187,801917,605469,309966,669615,273199,376282,11990,742909,184786,12314,433219,632135,704165,764274,121787,291357,595357,330699,696978,812726,785773,877411,568905,68252,392679,481112,650590,14033,77388,866399,369221,25895,310035,939501,896909,447960,581366,570456,1047449,786001,513043,883618,331612,180490,209582,987894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]