SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20418 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20418 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282128,556678,1030259,956167,364856,587512,891459,403657,181560,532224,869826,136366,635401,849044,210530,561803,475349,795896,830616,944546,861376,3126,62459,700547,44179,700080,57110,951812,597138,622405,1008098,184272,348947,35925,601117,577554,45889,922817,250480,462180,659145,713833,926009,28906,777166,357179,168184,469965,1038467,468178,654024,236768,574033,860299,837924,235469,254804,777187,974417,107450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]