SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44713 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44713 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524406,848170,365143,865450,21846,986165,672956,326796,459751,585436,938057,1018064,404701,967530,600424,537828,498519,367285,247143,989271,34716,289628,486133,489480,330359,477050,642340,567219,280244,3600,546729,645932,901690,478010,125725,548275,522344,504520,950885,294631,324479,293584,730381,1047481,161421,867756,191727,183248,385429,153008,746772,384898,549165,876725,343700,770800,55630,678623,621165,683610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]