SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400194 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400194 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445489,214345,693805,250549,42598,946837,74558,783571,762230,613592,883633,202540,364822,62376,874831,439931,403843,627248,292048,1048752,432157,4178,310861,855742,736436,171130,913026,891510,672265,958250,997102,396005,322075,303630,80943,248614,457172,569975,873831,822258,931822,94218,70061,351194,1034840,289541,825035,803581,301101,1226,693559,1042860,854436,656324,591119,543097,725840,159591,220940,986876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]