SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245028 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245028 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246399,147515,231872,149557,427309,861733,182704,399552,609129,726796,187830,177280,751987,26322,656760,644925,76894,709081,441481,602910,63377,1000236,854260,980234,605429,1018032,45299,410607,432329,451323,201281,528218,159115,253409,537469,707587,354952,109002,945659,327530,1004725,174432,247978,1047416,667121,964687,816492,221807,555140,207922,872125,130403,941977,56721,384175,245708,855383,925877,690183,325754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003339s ]