SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345017 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345017 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483199,820030,58936,302205,534230,779649,27433,505899,82493,432453,107242,509849,1940,303089,972603,51253,513178,962956,105658,849504,192112,989054,477013,883452,367513,589110,132438,329737,123815,112466,652675,674179,969493,248456,610241,343276,987885,4259,239970,800381,915370,664994,874763,466534,250427,780448,519344,914492,335313,232618,673755,732198,544383,749935,349738,700081,111545,904180,348032,59089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]