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` = 415904 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415904 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203811,1535,841813,4249,766911,110153,248216,854201,409148,835147,411931,425122,711649,585299,1016070,407105,170279,101680,293880,707497,1026457,906817,185167,199789,1020434,193726,856424,518476,401211,574629,32413,765529,405596,303250,552588,638412,608971,68913,377998,82952,908734,601651,745899,811592,730043,743254,85634,923903,589353,377954,1005476,191168,585636,1030179,67787,132589,357807,972530,502229,271414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002066s ]