SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004074 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004074 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353376,506781,221956,512172,681268,751076,892926,473320,757183,920315,109628,1038910,1004488,422088,144263,842143,928963,432258,205353,946430,678927,120801,458872,654220,733589,321453,271018,181765,653164,970109,774450,518150,390267,284318,42821,778747,338355,85339,419505,324546,1033310,302926,364736,636775,797332,621265,300202,28724,649276,941089,686782,9518,422207,469208,771955,455142,1001824,836101,141791,325975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001141s ]