SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286104 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286104 [ RunTime:0.003367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497323,534098,921910,546893,228035,968364,499957,352189,104037,906816,540252,27524,506465,120890,922118,445532,685382,310197,628088,682811,459738,686556,933035,245676,223640,877254,137022,319419,642444,23595,543761,611677,57105,613017,266565,236474,944150,620354,862821,488918,613740,385382,688058,478939,286095,279976,853360,679670,867451,639700,756532,153370,642636,1024411,964936,161525,106175,327165,276700,14123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]