SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038150 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038150 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623941,450738,641038,80061,49483,752053,1027865,964466,909042,517517,419427,612034,266008,151830,494928,99225,1040723,224296,680938,20245,726906,415805,374328,301969,270363,302444,955288,79088,268339,106188,31407,214275,925802,550021,996972,394686,876850,348092,587860,184807,342651,210908,52021,595247,540516,989189,478003,153673,194915,636316,725936,582175,286350,110796,697360,431129,436878,322428,392173,47946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]