SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036042 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036042 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181050,412711,93140,673219,278281,102,29399,729910,1005853,797864,176647,320142,893069,940341,351042,188436,971070,432499,1047333,646037,424173,28529,708425,83792,343505,369306,204529,398855,326242,580366,576148,433790,539939,670827,1016896,149568,723384,148606,18163,261754,1037050,499678,186677,655658,215706,353086,261320,38559,214299,249586,432681,37473,823403,582237,234390,895523,964081,282081,666022,496888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]