SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425188 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425188 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415308,9050,741519,22522,424418,350385,861132,103784,79995,220653,575593,1039304,997408,757192,451460,466579,368200,741288,61042,609987,146352,690472,109008,751699,194113,736432,777372,24770,171939,866604,643731,973816,418542,361661,93396,18023,16347,42801,745270,647466,624281,142241,891921,934595,491429,863484,897694,72967,753845,330060,684168,287146,22710,19173,192054,443933,724092,46402,737240,169751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001599s ]