SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415498 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415498 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344259,804013,62621,974356,112098,806731,288687,112396,694249,1043028,965324,955884,1024756,302675,461574,440537,371562,829078,360053,109770,666707,1020383,534160,264418,779524,490676,945206,500364,849386,139960,629982,292451,998108,969000,118514,120588,352321,391010,1045295,991959,948030,494429,925592,727861,61853,855358,837425,168656,345099,284574,404874,1042312,500756,147709,572894,528888,238443,529013,632431,567117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]