SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36442 LIMIT 1 [ RunTime:0.002969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36442 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182166,418959,920728,238118,913114,496905,681543,61185,727831,525409,786198,33548,583477,746341,349389,242655,741903,150015,624372,131034,954239,347183,6151,455526,956389,180022,53858,270238,941151,541034,383555,452485,1014142,551455,772551,280262,896248,836571,300026,514601,948018,381599,382635,318101,839395,415214,817,131125,928971,963655,96885,579091,356422,636384,140147,320864,582383,74933,27783,944428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002727s ]