SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001815s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40106 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40106 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772965,169238,589834,789034,337930,703276,132757,703216,222499,993968,606651,717984,343328,713053,357365,225874,749092,383494,7936,797177,663226,148204,435649,901945,286469,130153,286438,639151,821825,678670,536486,66369,734322,355637,174620,262402,264187,279891,701101,7176,704078,735253,350407,670874,87796,504966,711314,256167,66525,703172,22742,815985,819042,1010254,532645,535997,887616,646668,760330,996241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]